package com.tutu.flow.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BpmFormExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BpmFormExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFormIdIsNull() {
            addCriterion("FORM_ID is null");
            return (Criteria) this;
        }

        public Criteria andFormIdIsNotNull() {
            addCriterion("FORM_ID is not null");
            return (Criteria) this;
        }

        public Criteria andFormIdEqualTo(String value) {
            addCriterion("FORM_ID =", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdNotEqualTo(String value) {
            addCriterion("FORM_ID <>", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdGreaterThan(String value) {
            addCriterion("FORM_ID >", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdGreaterThanOrEqualTo(String value) {
            addCriterion("FORM_ID >=", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdLessThan(String value) {
            addCriterion("FORM_ID <", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdLessThanOrEqualTo(String value) {
            addCriterion("FORM_ID <=", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdLike(String value) {
            addCriterion("FORM_ID like", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdNotLike(String value) {
            addCriterion("FORM_ID not like", value, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdIn(List<String> values) {
            addCriterion("FORM_ID in", values, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdNotIn(List<String> values) {
            addCriterion("FORM_ID not in", values, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdBetween(String value1, String value2) {
            addCriterion("FORM_ID between", value1, value2, "formId");
            return (Criteria) this;
        }

        public Criteria andFormIdNotBetween(String value1, String value2) {
            addCriterion("FORM_ID not between", value1, value2, "formId");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNull() {
            addCriterion("CONTRACT_NO is null");
            return (Criteria) this;
        }

        public Criteria andContractNoIsNotNull() {
            addCriterion("CONTRACT_NO is not null");
            return (Criteria) this;
        }

        public Criteria andContractNoEqualTo(String value) {
            addCriterion("CONTRACT_NO =", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotEqualTo(String value) {
            addCriterion("CONTRACT_NO <>", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThan(String value) {
            addCriterion("CONTRACT_NO >", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoGreaterThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO >=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThan(String value) {
            addCriterion("CONTRACT_NO <", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLessThanOrEqualTo(String value) {
            addCriterion("CONTRACT_NO <=", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoLike(String value) {
            addCriterion("CONTRACT_NO like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotLike(String value) {
            addCriterion("CONTRACT_NO not like", value, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoIn(List<String> values) {
            addCriterion("CONTRACT_NO in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotIn(List<String> values) {
            addCriterion("CONTRACT_NO not in", values, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andContractNoNotBetween(String value1, String value2) {
            addCriterion("CONTRACT_NO not between", value1, value2, "contractNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoIsNull() {
            addCriterion("BUSINESS_NO is null");
            return (Criteria) this;
        }

        public Criteria andBusinessNoIsNotNull() {
            addCriterion("BUSINESS_NO is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessNoEqualTo(String value) {
            addCriterion("BUSINESS_NO =", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoNotEqualTo(String value) {
            addCriterion("BUSINESS_NO <>", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoGreaterThan(String value) {
            addCriterion("BUSINESS_NO >", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoGreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_NO >=", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoLessThan(String value) {
            addCriterion("BUSINESS_NO <", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoLessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_NO <=", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoLike(String value) {
            addCriterion("BUSINESS_NO like", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoNotLike(String value) {
            addCriterion("BUSINESS_NO not like", value, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoIn(List<String> values) {
            addCriterion("BUSINESS_NO in", values, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoNotIn(List<String> values) {
            addCriterion("BUSINESS_NO not in", values, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoBetween(String value1, String value2) {
            addCriterion("BUSINESS_NO between", value1, value2, "businessNo");
            return (Criteria) this;
        }

        public Criteria andBusinessNoNotBetween(String value1, String value2) {
            addCriterion("BUSINESS_NO not between", value1, value2, "businessNo");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("COMPANY_NAME is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("COMPANY_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("COMPANY_NAME =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("COMPANY_NAME <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("COMPANY_NAME >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("COMPANY_NAME >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("COMPANY_NAME <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("COMPANY_NAME <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("COMPANY_NAME like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("COMPANY_NAME not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("COMPANY_NAME in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("COMPANY_NAME not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("COMPANY_NAME between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("COMPANY_NAME not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressIsNull() {
            addCriterion("COMPANY_ADDRESS is null");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressIsNotNull() {
            addCriterion("COMPANY_ADDRESS is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressEqualTo(String value) {
            addCriterion("COMPANY_ADDRESS =", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotEqualTo(String value) {
            addCriterion("COMPANY_ADDRESS <>", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressGreaterThan(String value) {
            addCriterion("COMPANY_ADDRESS >", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressGreaterThanOrEqualTo(String value) {
            addCriterion("COMPANY_ADDRESS >=", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressLessThan(String value) {
            addCriterion("COMPANY_ADDRESS <", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressLessThanOrEqualTo(String value) {
            addCriterion("COMPANY_ADDRESS <=", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressLike(String value) {
            addCriterion("COMPANY_ADDRESS like", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotLike(String value) {
            addCriterion("COMPANY_ADDRESS not like", value, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressIn(List<String> values) {
            addCriterion("COMPANY_ADDRESS in", values, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotIn(List<String> values) {
            addCriterion("COMPANY_ADDRESS not in", values, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressBetween(String value1, String value2) {
            addCriterion("COMPANY_ADDRESS between", value1, value2, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andCompanyAddressNotBetween(String value1, String value2) {
            addCriterion("COMPANY_ADDRESS not between", value1, value2, "companyAddress");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeIsNull() {
            addCriterion("BUSINESS_SCOPE is null");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeIsNotNull() {
            addCriterion("BUSINESS_SCOPE is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeEqualTo(String value) {
            addCriterion("BUSINESS_SCOPE =", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeNotEqualTo(String value) {
            addCriterion("BUSINESS_SCOPE <>", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeGreaterThan(String value) {
            addCriterion("BUSINESS_SCOPE >", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeGreaterThanOrEqualTo(String value) {
            addCriterion("BUSINESS_SCOPE >=", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeLessThan(String value) {
            addCriterion("BUSINESS_SCOPE <", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeLessThanOrEqualTo(String value) {
            addCriterion("BUSINESS_SCOPE <=", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeLike(String value) {
            addCriterion("BUSINESS_SCOPE like", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeNotLike(String value) {
            addCriterion("BUSINESS_SCOPE not like", value, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeIn(List<String> values) {
            addCriterion("BUSINESS_SCOPE in", values, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeNotIn(List<String> values) {
            addCriterion("BUSINESS_SCOPE not in", values, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeBetween(String value1, String value2) {
            addCriterion("BUSINESS_SCOPE between", value1, value2, "businessScope");
            return (Criteria) this;
        }

        public Criteria andBusinessScopeNotBetween(String value1, String value2) {
            addCriterion("BUSINESS_SCOPE not between", value1, value2, "businessScope");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanIsNull() {
            addCriterion("FIRST_SALESMAN is null");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanIsNotNull() {
            addCriterion("FIRST_SALESMAN is not null");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanEqualTo(String value) {
            addCriterion("FIRST_SALESMAN =", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanNotEqualTo(String value) {
            addCriterion("FIRST_SALESMAN <>", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanGreaterThan(String value) {
            addCriterion("FIRST_SALESMAN >", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanGreaterThanOrEqualTo(String value) {
            addCriterion("FIRST_SALESMAN >=", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanLessThan(String value) {
            addCriterion("FIRST_SALESMAN <", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanLessThanOrEqualTo(String value) {
            addCriterion("FIRST_SALESMAN <=", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanLike(String value) {
            addCriterion("FIRST_SALESMAN like", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanNotLike(String value) {
            addCriterion("FIRST_SALESMAN not like", value, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanIn(List<String> values) {
            addCriterion("FIRST_SALESMAN in", values, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanNotIn(List<String> values) {
            addCriterion("FIRST_SALESMAN not in", values, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanBetween(String value1, String value2) {
            addCriterion("FIRST_SALESMAN between", value1, value2, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andFirstSalesmanNotBetween(String value1, String value2) {
            addCriterion("FIRST_SALESMAN not between", value1, value2, "firstSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanIsNull() {
            addCriterion("SECOND_SALESMAN is null");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanIsNotNull() {
            addCriterion("SECOND_SALESMAN is not null");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanEqualTo(String value) {
            addCriterion("SECOND_SALESMAN =", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanNotEqualTo(String value) {
            addCriterion("SECOND_SALESMAN <>", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanGreaterThan(String value) {
            addCriterion("SECOND_SALESMAN >", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanGreaterThanOrEqualTo(String value) {
            addCriterion("SECOND_SALESMAN >=", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanLessThan(String value) {
            addCriterion("SECOND_SALESMAN <", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanLessThanOrEqualTo(String value) {
            addCriterion("SECOND_SALESMAN <=", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanLike(String value) {
            addCriterion("SECOND_SALESMAN like", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanNotLike(String value) {
            addCriterion("SECOND_SALESMAN not like", value, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanIn(List<String> values) {
            addCriterion("SECOND_SALESMAN in", values, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanNotIn(List<String> values) {
            addCriterion("SECOND_SALESMAN not in", values, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanBetween(String value1, String value2) {
            addCriterion("SECOND_SALESMAN between", value1, value2, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andSecondSalesmanNotBetween(String value1, String value2) {
            addCriterion("SECOND_SALESMAN not between", value1, value2, "secondSalesman");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNull() {
            addCriterion("USER_NAME is null");
            return (Criteria) this;
        }

        public Criteria andUserNameIsNotNull() {
            addCriterion("USER_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andUserNameEqualTo(String value) {
            addCriterion("USER_NAME =", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotEqualTo(String value) {
            addCriterion("USER_NAME <>", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThan(String value) {
            addCriterion("USER_NAME >", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameGreaterThanOrEqualTo(String value) {
            addCriterion("USER_NAME >=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThan(String value) {
            addCriterion("USER_NAME <", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLessThanOrEqualTo(String value) {
            addCriterion("USER_NAME <=", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameLike(String value) {
            addCriterion("USER_NAME like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotLike(String value) {
            addCriterion("USER_NAME not like", value, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameIn(List<String> values) {
            addCriterion("USER_NAME in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotIn(List<String> values) {
            addCriterion("USER_NAME not in", values, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameBetween(String value1, String value2) {
            addCriterion("USER_NAME between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andUserNameNotBetween(String value1, String value2) {
            addCriterion("USER_NAME not between", value1, value2, "userName");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalIsNull() {
            addCriterion("REGISTERED_CAPITAL is null");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalIsNotNull() {
            addCriterion("REGISTERED_CAPITAL is not null");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalEqualTo(String value) {
            addCriterion("REGISTERED_CAPITAL =", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotEqualTo(String value) {
            addCriterion("REGISTERED_CAPITAL <>", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalGreaterThan(String value) {
            addCriterion("REGISTERED_CAPITAL >", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalGreaterThanOrEqualTo(String value) {
            addCriterion("REGISTERED_CAPITAL >=", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalLessThan(String value) {
            addCriterion("REGISTERED_CAPITAL <", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalLessThanOrEqualTo(String value) {
            addCriterion("REGISTERED_CAPITAL <=", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalLike(String value) {
            addCriterion("REGISTERED_CAPITAL like", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotLike(String value) {
            addCriterion("REGISTERED_CAPITAL not like", value, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalIn(List<String> values) {
            addCriterion("REGISTERED_CAPITAL in", values, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotIn(List<String> values) {
            addCriterion("REGISTERED_CAPITAL not in", values, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalBetween(String value1, String value2) {
            addCriterion("REGISTERED_CAPITAL between", value1, value2, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andRegisteredCapitalNotBetween(String value1, String value2) {
            addCriterion("REGISTERED_CAPITAL not between", value1, value2, "registeredCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalIsNull() {
            addCriterion("PAID_CAPITAL is null");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalIsNotNull() {
            addCriterion("PAID_CAPITAL is not null");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalEqualTo(String value) {
            addCriterion("PAID_CAPITAL =", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalNotEqualTo(String value) {
            addCriterion("PAID_CAPITAL <>", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalGreaterThan(String value) {
            addCriterion("PAID_CAPITAL >", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalGreaterThanOrEqualTo(String value) {
            addCriterion("PAID_CAPITAL >=", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalLessThan(String value) {
            addCriterion("PAID_CAPITAL <", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalLessThanOrEqualTo(String value) {
            addCriterion("PAID_CAPITAL <=", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalLike(String value) {
            addCriterion("PAID_CAPITAL like", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalNotLike(String value) {
            addCriterion("PAID_CAPITAL not like", value, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalIn(List<String> values) {
            addCriterion("PAID_CAPITAL in", values, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalNotIn(List<String> values) {
            addCriterion("PAID_CAPITAL not in", values, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalBetween(String value1, String value2) {
            addCriterion("PAID_CAPITAL between", value1, value2, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andPaidCapitalNotBetween(String value1, String value2) {
            addCriterion("PAID_CAPITAL not between", value1, value2, "paidCapital");
            return (Criteria) this;
        }

        public Criteria andContractAmountIsNull() {
            addCriterion("CONTRACT_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andContractAmountIsNotNull() {
            addCriterion("CONTRACT_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andContractAmountEqualTo(BigDecimal value) {
            addCriterion("CONTRACT_AMOUNT =", value, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountNotEqualTo(BigDecimal value) {
            addCriterion("CONTRACT_AMOUNT <>", value, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountGreaterThan(BigDecimal value) {
            addCriterion("CONTRACT_AMOUNT >", value, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("CONTRACT_AMOUNT >=", value, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountLessThan(BigDecimal value) {
            addCriterion("CONTRACT_AMOUNT <", value, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("CONTRACT_AMOUNT <=", value, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountIn(List<BigDecimal> values) {
            addCriterion("CONTRACT_AMOUNT in", values, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountNotIn(List<BigDecimal> values) {
            addCriterion("CONTRACT_AMOUNT not in", values, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CONTRACT_AMOUNT between", value1, value2, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andContractAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("CONTRACT_AMOUNT not between", value1, value2, "contractAmount");
            return (Criteria) this;
        }

        public Criteria andPaymentWayIsNull() {
            addCriterion("PAYMENT_WAY is null");
            return (Criteria) this;
        }

        public Criteria andPaymentWayIsNotNull() {
            addCriterion("PAYMENT_WAY is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentWayEqualTo(String value) {
            addCriterion("PAYMENT_WAY =", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotEqualTo(String value) {
            addCriterion("PAYMENT_WAY <>", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayGreaterThan(String value) {
            addCriterion("PAYMENT_WAY >", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayGreaterThanOrEqualTo(String value) {
            addCriterion("PAYMENT_WAY >=", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayLessThan(String value) {
            addCriterion("PAYMENT_WAY <", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayLessThanOrEqualTo(String value) {
            addCriterion("PAYMENT_WAY <=", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayLike(String value) {
            addCriterion("PAYMENT_WAY like", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotLike(String value) {
            addCriterion("PAYMENT_WAY not like", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayIn(List<String> values) {
            addCriterion("PAYMENT_WAY in", values, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotIn(List<String> values) {
            addCriterion("PAYMENT_WAY not in", values, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayBetween(String value1, String value2) {
            addCriterion("PAYMENT_WAY between", value1, value2, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotBetween(String value1, String value2) {
            addCriterion("PAYMENT_WAY not between", value1, value2, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andNominalFeeIsNull() {
            addCriterion("NOMINAL_FEE is null");
            return (Criteria) this;
        }

        public Criteria andNominalFeeIsNotNull() {
            addCriterion("NOMINAL_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andNominalFeeEqualTo(BigDecimal value) {
            addCriterion("NOMINAL_FEE =", value, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeNotEqualTo(BigDecimal value) {
            addCriterion("NOMINAL_FEE <>", value, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeGreaterThan(BigDecimal value) {
            addCriterion("NOMINAL_FEE >", value, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("NOMINAL_FEE >=", value, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeLessThan(BigDecimal value) {
            addCriterion("NOMINAL_FEE <", value, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("NOMINAL_FEE <=", value, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeIn(List<BigDecimal> values) {
            addCriterion("NOMINAL_FEE in", values, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeNotIn(List<BigDecimal> values) {
            addCriterion("NOMINAL_FEE not in", values, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NOMINAL_FEE between", value1, value2, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andNominalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("NOMINAL_FEE not between", value1, value2, "nominalFee");
            return (Criteria) this;
        }

        public Criteria andCaIsNull() {
            addCriterion("CA is null");
            return (Criteria) this;
        }

        public Criteria andCaIsNotNull() {
            addCriterion("CA is not null");
            return (Criteria) this;
        }

        public Criteria andCaEqualTo(String value) {
            addCriterion("CA =", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaNotEqualTo(String value) {
            addCriterion("CA <>", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaGreaterThan(String value) {
            addCriterion("CA >", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaGreaterThanOrEqualTo(String value) {
            addCriterion("CA >=", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaLessThan(String value) {
            addCriterion("CA <", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaLessThanOrEqualTo(String value) {
            addCriterion("CA <=", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaLike(String value) {
            addCriterion("CA like", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaNotLike(String value) {
            addCriterion("CA not like", value, "ca");
            return (Criteria) this;
        }

        public Criteria andCaIn(List<String> values) {
            addCriterion("CA in", values, "ca");
            return (Criteria) this;
        }

        public Criteria andCaNotIn(List<String> values) {
            addCriterion("CA not in", values, "ca");
            return (Criteria) this;
        }

        public Criteria andCaBetween(String value1, String value2) {
            addCriterion("CA between", value1, value2, "ca");
            return (Criteria) this;
        }

        public Criteria andCaNotBetween(String value1, String value2) {
            addCriterion("CA not between", value1, value2, "ca");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileIsNull() {
            addCriterion("IS_TALLY_NETFILE is null");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileIsNotNull() {
            addCriterion("IS_TALLY_NETFILE is not null");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileEqualTo(String value) {
            addCriterion("IS_TALLY_NETFILE =", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileNotEqualTo(String value) {
            addCriterion("IS_TALLY_NETFILE <>", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileGreaterThan(String value) {
            addCriterion("IS_TALLY_NETFILE >", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileGreaterThanOrEqualTo(String value) {
            addCriterion("IS_TALLY_NETFILE >=", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileLessThan(String value) {
            addCriterion("IS_TALLY_NETFILE <", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileLessThanOrEqualTo(String value) {
            addCriterion("IS_TALLY_NETFILE <=", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileLike(String value) {
            addCriterion("IS_TALLY_NETFILE like", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileNotLike(String value) {
            addCriterion("IS_TALLY_NETFILE not like", value, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileIn(List<String> values) {
            addCriterion("IS_TALLY_NETFILE in", values, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileNotIn(List<String> values) {
            addCriterion("IS_TALLY_NETFILE not in", values, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileBetween(String value1, String value2) {
            addCriterion("IS_TALLY_NETFILE between", value1, value2, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andIsTallyNetfileNotBetween(String value1, String value2) {
            addCriterion("IS_TALLY_NETFILE not between", value1, value2, "isTallyNetfile");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerIsNull() {
            addCriterion("NOMINAL_FEE_BEARER is null");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerIsNotNull() {
            addCriterion("NOMINAL_FEE_BEARER is not null");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerEqualTo(String value) {
            addCriterion("NOMINAL_FEE_BEARER =", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerNotEqualTo(String value) {
            addCriterion("NOMINAL_FEE_BEARER <>", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerGreaterThan(String value) {
            addCriterion("NOMINAL_FEE_BEARER >", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerGreaterThanOrEqualTo(String value) {
            addCriterion("NOMINAL_FEE_BEARER >=", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerLessThan(String value) {
            addCriterion("NOMINAL_FEE_BEARER <", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerLessThanOrEqualTo(String value) {
            addCriterion("NOMINAL_FEE_BEARER <=", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerLike(String value) {
            addCriterion("NOMINAL_FEE_BEARER like", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerNotLike(String value) {
            addCriterion("NOMINAL_FEE_BEARER not like", value, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerIn(List<String> values) {
            addCriterion("NOMINAL_FEE_BEARER in", values, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerNotIn(List<String> values) {
            addCriterion("NOMINAL_FEE_BEARER not in", values, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerBetween(String value1, String value2) {
            addCriterion("NOMINAL_FEE_BEARER between", value1, value2, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andNominalFeeBearerNotBetween(String value1, String value2) {
            addCriterion("NOMINAL_FEE_BEARER not between", value1, value2, "nominalFeeBearer");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeIsNull() {
            addCriterion("MONTHLY_FEE is null");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeIsNotNull() {
            addCriterion("MONTHLY_FEE is not null");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeEqualTo(BigDecimal value) {
            addCriterion("MONTHLY_FEE =", value, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeNotEqualTo(BigDecimal value) {
            addCriterion("MONTHLY_FEE <>", value, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeGreaterThan(BigDecimal value) {
            addCriterion("MONTHLY_FEE >", value, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MONTHLY_FEE >=", value, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeLessThan(BigDecimal value) {
            addCriterion("MONTHLY_FEE <", value, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MONTHLY_FEE <=", value, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeIn(List<BigDecimal> values) {
            addCriterion("MONTHLY_FEE in", values, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeNotIn(List<BigDecimal> values) {
            addCriterion("MONTHLY_FEE not in", values, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MONTHLY_FEE between", value1, value2, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andMonthlyFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MONTHLY_FEE not between", value1, value2, "monthlyFee");
            return (Criteria) this;
        }

        public Criteria andReceivableIsNull() {
            addCriterion("RECEIVABLE is null");
            return (Criteria) this;
        }

        public Criteria andReceivableIsNotNull() {
            addCriterion("RECEIVABLE is not null");
            return (Criteria) this;
        }

        public Criteria andReceivableEqualTo(BigDecimal value) {
            addCriterion("RECEIVABLE =", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableNotEqualTo(BigDecimal value) {
            addCriterion("RECEIVABLE <>", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableGreaterThan(BigDecimal value) {
            addCriterion("RECEIVABLE >", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("RECEIVABLE >=", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableLessThan(BigDecimal value) {
            addCriterion("RECEIVABLE <", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableLessThanOrEqualTo(BigDecimal value) {
            addCriterion("RECEIVABLE <=", value, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableIn(List<BigDecimal> values) {
            addCriterion("RECEIVABLE in", values, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableNotIn(List<BigDecimal> values) {
            addCriterion("RECEIVABLE not in", values, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RECEIVABLE between", value1, value2, "receivable");
            return (Criteria) this;
        }

        public Criteria andReceivableNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("RECEIVABLE not between", value1, value2, "receivable");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("REMARK like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("REMARK not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("REMARK in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andAdjunctIsNull() {
            addCriterion("ADJUNCT is null");
            return (Criteria) this;
        }

        public Criteria andAdjunctIsNotNull() {
            addCriterion("ADJUNCT is not null");
            return (Criteria) this;
        }

        public Criteria andAdjunctEqualTo(String value) {
            addCriterion("ADJUNCT =", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctNotEqualTo(String value) {
            addCriterion("ADJUNCT <>", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctGreaterThan(String value) {
            addCriterion("ADJUNCT >", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctGreaterThanOrEqualTo(String value) {
            addCriterion("ADJUNCT >=", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctLessThan(String value) {
            addCriterion("ADJUNCT <", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctLessThanOrEqualTo(String value) {
            addCriterion("ADJUNCT <=", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctLike(String value) {
            addCriterion("ADJUNCT like", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctNotLike(String value) {
            addCriterion("ADJUNCT not like", value, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctIn(List<String> values) {
            addCriterion("ADJUNCT in", values, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctNotIn(List<String> values) {
            addCriterion("ADJUNCT not in", values, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctBetween(String value1, String value2) {
            addCriterion("ADJUNCT between", value1, value2, "adjunct");
            return (Criteria) this;
        }

        public Criteria andAdjunctNotBetween(String value1, String value2) {
            addCriterion("ADJUNCT not between", value1, value2, "adjunct");
            return (Criteria) this;
        }

        public Criteria andProcInstIdIsNull() {
            addCriterion("PROC_INST_ID is null");
            return (Criteria) this;
        }

        public Criteria andProcInstIdIsNotNull() {
            addCriterion("PROC_INST_ID is not null");
            return (Criteria) this;
        }

        public Criteria andProcInstIdEqualTo(String value) {
            addCriterion("PROC_INST_ID =", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdNotEqualTo(String value) {
            addCriterion("PROC_INST_ID <>", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdGreaterThan(String value) {
            addCriterion("PROC_INST_ID >", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdGreaterThanOrEqualTo(String value) {
            addCriterion("PROC_INST_ID >=", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdLessThan(String value) {
            addCriterion("PROC_INST_ID <", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdLessThanOrEqualTo(String value) {
            addCriterion("PROC_INST_ID <=", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdLike(String value) {
            addCriterion("PROC_INST_ID like", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdNotLike(String value) {
            addCriterion("PROC_INST_ID not like", value, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdIn(List<String> values) {
            addCriterion("PROC_INST_ID in", values, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdNotIn(List<String> values) {
            addCriterion("PROC_INST_ID not in", values, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdBetween(String value1, String value2) {
            addCriterion("PROC_INST_ID between", value1, value2, "procInstId");
            return (Criteria) this;
        }

        public Criteria andProcInstIdNotBetween(String value1, String value2) {
            addCriterion("PROC_INST_ID not between", value1, value2, "procInstId");
            return (Criteria) this;
        }

        public Criteria andAliveFlagIsNull() {
            addCriterion("ALIVE_FLAG is null");
            return (Criteria) this;
        }

        public Criteria andAliveFlagIsNotNull() {
            addCriterion("ALIVE_FLAG is not null");
            return (Criteria) this;
        }

        public Criteria andAliveFlagEqualTo(String value) {
            addCriterion("ALIVE_FLAG =", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagNotEqualTo(String value) {
            addCriterion("ALIVE_FLAG <>", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagGreaterThan(String value) {
            addCriterion("ALIVE_FLAG >", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagGreaterThanOrEqualTo(String value) {
            addCriterion("ALIVE_FLAG >=", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagLessThan(String value) {
            addCriterion("ALIVE_FLAG <", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagLessThanOrEqualTo(String value) {
            addCriterion("ALIVE_FLAG <=", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagLike(String value) {
            addCriterion("ALIVE_FLAG like", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagNotLike(String value) {
            addCriterion("ALIVE_FLAG not like", value, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagIn(List<String> values) {
            addCriterion("ALIVE_FLAG in", values, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagNotIn(List<String> values) {
            addCriterion("ALIVE_FLAG not in", values, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagBetween(String value1, String value2) {
            addCriterion("ALIVE_FLAG between", value1, value2, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andAliveFlagNotBetween(String value1, String value2) {
            addCriterion("ALIVE_FLAG not between", value1, value2, "aliveFlag");
            return (Criteria) this;
        }

        public Criteria andCreatorIsNull() {
            addCriterion("CREATOR is null");
            return (Criteria) this;
        }

        public Criteria andCreatorIsNotNull() {
            addCriterion("CREATOR is not null");
            return (Criteria) this;
        }

        public Criteria andCreatorEqualTo(String value) {
            addCriterion("CREATOR =", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotEqualTo(String value) {
            addCriterion("CREATOR <>", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorGreaterThan(String value) {
            addCriterion("CREATOR >", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorGreaterThanOrEqualTo(String value) {
            addCriterion("CREATOR >=", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLessThan(String value) {
            addCriterion("CREATOR <", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLessThanOrEqualTo(String value) {
            addCriterion("CREATOR <=", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorLike(String value) {
            addCriterion("CREATOR like", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotLike(String value) {
            addCriterion("CREATOR not like", value, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorIn(List<String> values) {
            addCriterion("CREATOR in", values, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotIn(List<String> values) {
            addCriterion("CREATOR not in", values, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorBetween(String value1, String value2) {
            addCriterion("CREATOR between", value1, value2, "creator");
            return (Criteria) this;
        }

        public Criteria andCreatorNotBetween(String value1, String value2) {
            addCriterion("CREATOR not between", value1, value2, "creator");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andModifierIsNull() {
            addCriterion("MODIFIER is null");
            return (Criteria) this;
        }

        public Criteria andModifierIsNotNull() {
            addCriterion("MODIFIER is not null");
            return (Criteria) this;
        }

        public Criteria andModifierEqualTo(String value) {
            addCriterion("MODIFIER =", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotEqualTo(String value) {
            addCriterion("MODIFIER <>", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierGreaterThan(String value) {
            addCriterion("MODIFIER >", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierGreaterThanOrEqualTo(String value) {
            addCriterion("MODIFIER >=", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLessThan(String value) {
            addCriterion("MODIFIER <", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLessThanOrEqualTo(String value) {
            addCriterion("MODIFIER <=", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierLike(String value) {
            addCriterion("MODIFIER like", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotLike(String value) {
            addCriterion("MODIFIER not like", value, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierIn(List<String> values) {
            addCriterion("MODIFIER in", values, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotIn(List<String> values) {
            addCriterion("MODIFIER not in", values, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierBetween(String value1, String value2) {
            addCriterion("MODIFIER between", value1, value2, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifierNotBetween(String value1, String value2) {
            addCriterion("MODIFIER not between", value1, value2, "modifier");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNull() {
            addCriterion("MODIFY_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIsNotNull() {
            addCriterion("MODIFY_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifyTimeEqualTo(Date value) {
            addCriterion("MODIFY_TIME =", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotEqualTo(Date value) {
            addCriterion("MODIFY_TIME <>", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThan(Date value) {
            addCriterion("MODIFY_TIME >", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("MODIFY_TIME >=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThan(Date value) {
            addCriterion("MODIFY_TIME <", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeLessThanOrEqualTo(Date value) {
            addCriterion("MODIFY_TIME <=", value, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeIn(List<Date> values) {
            addCriterion("MODIFY_TIME in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotIn(List<Date> values) {
            addCriterion("MODIFY_TIME not in", values, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeBetween(Date value1, Date value2) {
            addCriterion("MODIFY_TIME between", value1, value2, "modifyTime");
            return (Criteria) this;
        }

        public Criteria andModifyTimeNotBetween(Date value1, Date value2) {
            addCriterion("MODIFY_TIME not between", value1, value2, "modifyTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }

        public Criteria andFormIdLikeInsensitive(String value) {
            addCriterion("upper(FORM_ID) like", value.toUpperCase(), "formId");
            return this;
        }

        public Criteria andContractNoLikeInsensitive(String value) {
            addCriterion("upper(CONTRACT_NO) like", value.toUpperCase(), "contractNo");
            return this;
        }

        public Criteria andBusinessNoLikeInsensitive(String value) {
            addCriterion("upper(BUSINESS_NO) like", value.toUpperCase(), "businessNo");
            return this;
        }

        public Criteria andCompanyNameLikeInsensitive(String value) {
            addCriterion("upper(COMPANY_NAME) like", value.toUpperCase(), "companyName");
            return this;
        }

        public Criteria andCompanyAddressLikeInsensitive(String value) {
            addCriterion("upper(COMPANY_ADDRESS) like", value.toUpperCase(), "companyAddress");
            return this;
        }

        public Criteria andBusinessScopeLikeInsensitive(String value) {
            addCriterion("upper(BUSINESS_SCOPE) like", value.toUpperCase(), "businessScope");
            return this;
        }

        public Criteria andFirstSalesmanLikeInsensitive(String value) {
            addCriterion("upper(FIRST_SALESMAN) like", value.toUpperCase(), "firstSalesman");
            return this;
        }

        public Criteria andSecondSalesmanLikeInsensitive(String value) {
            addCriterion("upper(SECOND_SALESMAN) like", value.toUpperCase(), "secondSalesman");
            return this;
        }

        public Criteria andUserNameLikeInsensitive(String value) {
            addCriterion("upper(USER_NAME) like", value.toUpperCase(), "userName");
            return this;
        }

        public Criteria andRegisteredCapitalLikeInsensitive(String value) {
            addCriterion("upper(REGISTERED_CAPITAL) like", value.toUpperCase(), "registeredCapital");
            return this;
        }

        public Criteria andPaidCapitalLikeInsensitive(String value) {
            addCriterion("upper(PAID_CAPITAL) like", value.toUpperCase(), "paidCapital");
            return this;
        }

        public Criteria andPaymentWayLikeInsensitive(String value) {
            addCriterion("upper(PAYMENT_WAY) like", value.toUpperCase(), "paymentWay");
            return this;
        }

        public Criteria andCaLikeInsensitive(String value) {
            addCriterion("upper(CA) like", value.toUpperCase(), "ca");
            return this;
        }

        public Criteria andIsTallyNetfileLikeInsensitive(String value) {
            addCriterion("upper(IS_TALLY_NETFILE) like", value.toUpperCase(), "isTallyNetfile");
            return this;
        }

        public Criteria andNominalFeeBearerLikeInsensitive(String value) {
            addCriterion("upper(NOMINAL_FEE_BEARER) like", value.toUpperCase(), "nominalFeeBearer");
            return this;
        }

        public Criteria andRemarkLikeInsensitive(String value) {
            addCriterion("upper(REMARK) like", value.toUpperCase(), "remark");
            return this;
        }

        public Criteria andAdjunctLikeInsensitive(String value) {
            addCriterion("upper(ADJUNCT) like", value.toUpperCase(), "adjunct");
            return this;
        }

        public Criteria andProcInstIdLikeInsensitive(String value) {
            addCriterion("upper(PROC_INST_ID) like", value.toUpperCase(), "procInstId");
            return this;
        }

        public Criteria andAliveFlagLikeInsensitive(String value) {
            addCriterion("upper(ALIVE_FLAG) like", value.toUpperCase(), "aliveFlag");
            return this;
        }

        public Criteria andCreatorLikeInsensitive(String value) {
            addCriterion("upper(CREATOR) like", value.toUpperCase(), "creator");
            return this;
        }

        public Criteria andModifierLikeInsensitive(String value) {
            addCriterion("upper(MODIFIER) like", value.toUpperCase(), "modifier");
            return this;
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}